Sheet: (0, 0) identifica (0, 1) oggetti (0, 2) nome_oggetto (0, 3) numero_ogg_luce (0, 4) crea matrice (0, 5) parent_goal_object (0, 6) luci (0, 7) camera (0, 8) riordina (0, 9) Roberto's Alphabetizer for Lightwave 3D v2.0 (1, 0) TRUE (1, 1) TRUE (1, 2) TRUE (1, 3) TRUE (1, 4) fisso il numero d'ordine della 3^ colonna (1, 5) seleziono la sezione dalla fine elenco oggetto a fine oggetti (1, 7) TRUE (1, 9) by Barbaglio Roberto & Amadini Riccardo ©1997 (2, 0) TRUE (2, 1) TRUE (2, 2) TRUE (2, 3) TRUE (2, 4) TRUE (2, 5) TRUE (2, 6) TRUE (2, 8) TRUE (2, 9) (3, 1) TRUE (3, 2) TRUE (3, 3) TRUE (3, 4) TRUE (3, 5) ordino in funzione del numero in colonna 6 (3, 7) TRUE (3, 8) TRUE (3, 9) In order to use Alphabetizer: (4, 0) TRUE (4, 1) TRUE (4, 2) TRUE (4, 3) TRUE (4, 4) TRUE (4, 5) TRUE (4, 6) TRUE (4, 7) TRUE (4, 9) (5, 0) TRUE (5, 1) #N/A! (5, 2) TRUE (5, 3) TRUE (5, 4) ordino in funzione della colonna del numero degli oggetti (5, 5) seleziono la prima riga interessata (5, 6) TRUE (5, 7) TRUE (5, 8) TRUE (5, 9) Load the Lightwave scene that has to be alphabetized (6, 0) TRUE (6, 1) TRUE (6, 2) FALSE (6, 3) TRUE (6, 4) TRUE (6, 5) TRUE (6, 6) TRUE (6, 8) TRUE (6, 9) If you are using Excel 4.0 the scene will be automatically converted in a text file. (7, 0) FALSE (7, 1) TRUE (7, 2) TRUE (7, 3) TRUE (7, 4) TRUE (7, 5) cambio dell'oggetto con quello nuovo corrispondente (7, 6) TRUE (7, 7) TRUE (7, 9) If you are using Excel 95 or later it will open a three steps requester: (8, 0) TRUE (8, 1) TRUE (8, 2) TRUE (8, 4) (8, 5) TRUE (8, 6) TRUE (8, 7) TRUE (8, 8) TRUE (8, 9) In the first step chose DELIMITED (leave unchanged other options!) (9, 0) TRUE (9, 1) #N/A! (9, 2) FALSE (9, 4) ordino gli oggetti in ordine alfabetico (9, 5) TRUE (9, 7) TRUE (9, 8) TRUE (9, 9) In the second step only select TABULATION. (10, 0) FALSE (10, 1) TRUE (10, 2) TRUE (10, 4) TRUE (10, 5) TRUE (10, 6) TRUE (10, 7) (10, 8) TRUE (10, 9) In the last step chose TEXT. (11, 0) TRUE (11, 1) TRUE (11, 2) TRUE (11, 4) TRUE (11, 5) TRUE (11, 6) TRUE (11, 7) TRUE (11, 8) (12, 0) TRUE (12, 1) TRUE (12, 2) TRUE (12, 4) fisso la posizione degli oggetti (12, 5) (12, 6) TRUE (12, 7) TRUE (12, 9) From the Excel's Lightwave scene window: (13, 0) TRUE (13, 1) #N/A! (13, 2) TRUE (13, 4) TRUE (13, 5) (13, 6) TRUE (13, 7) TRUE (13, 9) Run the macro with CTRL+a. (14, 0) TRUE (14, 1) TRUE (14, 2) TRUE (14, 4) TRUE (14, 5) TRUE (14, 6) (14, 7) (14, 8) (14, 9) Follow the on screen indications. (15, 0) TRUE (15, 1) TRUE (15, 2) TRUE (15, 4) TRUE (15, 6) TRUE (15, 9) (16, 0) TRUE (16, 1) TRUE (16, 2) TRUE (16, 4) riordino gli oggetti in funzione del numero originale (16, 6) TRUE (16, 7) TRUE (16, 8) TRUE (16, 9) The scene will be processed, a message will inform you that the scene has been processed correctly. (17, 0) TRUE (17, 1) TRUE (17, 4) TRUE (17, 6) TRUE (17, 9) Use the SAVE AS command and save the scene with a different name. (18, 0) TRUE (18, 1) #N/A! (18, 4) TRUE (18, 5) (18, 6) TRUE (18, 9) (19, 0) TRUE (19, 1) TRUE (19, 4) definisco la matrice "numero oggetto/posizione in ordine alfabetico" (19, 6) (19, 7) (19, 8) (19, 9) Always save the scene file as TEXT!! (this is the default save format since you loaded a text file). (20, 0) TRUE (20, 1) TRUE (20, 4) TRUE (20, 6) TRUE (20, 9) (21, 0) TRUE (21, 1) TRUE (21, 4) TRUE (21, 6) (21, 7) (21, 8) (21, 9) Thank you. (22, 0) TRUE (22, 1) TRUE (22, 6) TRUE (23, 0) TRUE (23, 1) TRUE (23, 4) TRUE (23, 5) (23, 6) TRUE (24, 0) TRUE (24, 1) TRUE (24, 5) (25, 0) TRUE (25, 1) TRUE (25, 5) (25, 6) TRUE (26, 0) TRUE (26, 1) TRUE (26, 5) (26, 6) TRUE (27, 0) TRUE (27, 1) TRUE (27, 5) (27, 6) TRUE (28, 0) TRUE (28, 1) TRUE (28, 5) (28, 6) TRUE (29, 0) TRUE (29, 1) TRUE (29, 5) (29, 6) TRUE (30, 1) TRUE (30, 5) (30, 6) TRUE (31, 0) Identifica le aree "oggetti" e "luci" (31, 1) (31, 5) (31, 6) (31, 7) (31, 8) (32, 0) TRUE (32, 5) (32, 6) TRUE (33, 0) TRUE (33, 5) (33, 6) (33, 7) (33, 8) (34, 0) TRUE (34, 5) (34, 6) (34, 7) (34, 8) (35, 0) TRUE (35, 5) (35, 6) (35, 7) (35, 8) (36, 0) TRUE (36, 5) (36, 6) (36, 7) (36, 8) (37, 0) TRUE (37, 5) (37, 6) (37, 7) (37, 8) (38, 0) TRUE (38, 5) (38, 6) (38, 7) (38, 8) (39, 0) TRUE (39, 5) (39, 6) (39, 7) (39, 8) (40, 0) TRUE (40, 5) (40, 6) (40, 7) (40, 8) (41, 0) TRUE (41, 5) (41, 6) (41, 7) (41, 8) (42, 0) TRUE (42, 5) (42, 6) (42, 7) (42, 8) (43, 0) TRUE (43, 5) (43, 6) (43, 7) (43, 8) (44, 0) (44, 5) (44, 6) (44, 7) (44, 8) (45, 0) (45, 5) (45, 6) (45, 7) (45, 8) (46, 0) TRUE (46, 5) (46, 6) (46, 7) (46, 8) (47, 0) TRUE (47, 5) (48, 0) TRUE (48, 5) (49, 0) TRUE (49, 5) (50, 0) FALSE (50, 5) (51, 0) TRUE (51, 5) (52, 0) TRUE (52, 5) (53, 0) TRUE (53, 5) (54, 0) TRUE (54, 5) (55, 0) (55, 5) (56, 0) TRUE (56, 5) (57, 0) TRUE (57, 5) (58, 0) TRUE (58, 5) (59, 0) TRUE (59, 5) (60, 0) (60, 5) (61, 0) (61, 5) (62, 0) #N/A! (62, 5) (63, 0) #N/A! (63, 5) (64, 0) #N/A! (64, 5) (65, 0) #N/A! (65, 5) (66, 0) #N/A! (66, 5) (67, 0) #N/A! (67, 5) (68, 5) (69, 0) vengono ora riaggiustati i parent per i bones (69, 5) (70, 0) TRUE (70, 5) (71, 0) TRUE (71, 5) (72, 0) TRUE (72, 5) (73, 0) TRUE (73, 5) (74, 0) TRUE (75, 0) TRUE (76, 0) TRUE (77, 0) TRUE (78, 0) TRUE (79, 0) TRUE (80, 0) TRUE (81, 0) TRUE (83, 0) TRUE (84, 0) TRUE (85, 0) TRUE (87, 0) TRUE (89, 0) TRUE